/*==============================================================*/
/* Table: CLC_STANDARD_METRIC_RECORD                            */
/*==============================================================*/
CREATE TABLE ZOECOLLECT.CLC_STANDARD_METRIC_RECORD 
(
   COLLECT_NO           NUMBER               DEFAULT ZOECOLLECT.SEQ_CLC_STANDARD_METRIC_RECORD.NEXTVAL NOT NULL,
   METRIC_ID            VARCHAR2(128 CHAR),
   METRIC_VALUE         NUMBER,
   COLLECT_TIME         DATE,
   CONSTRAINT PK_CLC_STANDARD_METRIC_RECORD PRIMARY KEY (COLLECT_NO)
         USING INDEX
);

COMMENT ON TABLE ZOECOLLECT.CLC_STANDARD_METRIC_RECORD IS
'标准指标记录';

COMMENT ON COLUMN ZOECOLLECT.CLC_STANDARD_METRIC_RECORD.COLLECT_NO IS
'记录流水号';

COMMENT ON COLUMN ZOECOLLECT.CLC_STANDARD_METRIC_RECORD.METRIC_ID IS
'指标ID';

COMMENT ON COLUMN ZOECOLLECT.CLC_STANDARD_METRIC_RECORD.METRIC_VALUE IS
'指标值';

COMMENT ON COLUMN ZOECOLLECT.CLC_STANDARD_METRIC_RECORD.COLLECT_TIME IS
'采集时间';


/*==============================================================*/
/* Table: CLC_TREND_SPACE_USED                                  */
/*==============================================================*/
CREATE TABLE ZOECOLLECT.CLC_TREND_SPACE_USED 
(
   COLLECT_NO           NUMBER               DEFAULT ZOECOLLECT.SEQ_CLC_TREND_SPACE_USED.NEXTVAL NOT NULL,
   SPACE_NAME           VARCHAR2(128 CHAR)   NOT NULL,
   SPACE_TYPE           VARCHAR2(128 CHAR),
   COLLECT_TIME         DATE,
   COLLECT_VALUE        NUMBER,
   CONSTRAINT PK_CLC_TREND_SPACE_USED PRIMARY KEY (COLLECT_NO)
         USING INDEX
);

COMMENT ON TABLE ZOECOLLECT.CLC_TREND_SPACE_USED IS
'空间使用趋势';

COMMENT ON COLUMN ZOECOLLECT.CLC_TREND_SPACE_USED.COLLECT_NO IS
'记录流水号';

COMMENT ON COLUMN ZOECOLLECT.CLC_TREND_SPACE_USED.SPACE_NAME IS
'空间对象名称#|[ALL_DATAFILES,ALL_SEGMENTS,ALL_TABLES,ZOEHIS5_SEGMENTS]';

COMMENT ON COLUMN ZOECOLLECT.CLC_TREND_SPACE_USED.SPACE_TYPE IS
'空间对象类型#|[DATABASE,SEGMENT,TABLE]';

COMMENT ON COLUMN ZOECOLLECT.CLC_TREND_SPACE_USED.COLLECT_TIME IS
'采集时间';

COMMENT ON COLUMN ZOECOLLECT.CLC_TREND_SPACE_USED.COLLECT_VALUE IS
'采集值';

